StudentRefundCalculation 
EntityType  Independent 
Logical Entity Name  StudentRefundCalculation 
Default Table Name  SaRefundCalc 
Logical Only  NO 
Definition 
 
Note 
 

StudentRefundCalculation Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentRefundCalculationId(PK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 
EffectiveDate    DATETIME  YES 
 
CalculationDate    DATETIME  YES 
 
Description    VARCHAR(50)  NO 
 
Type    CHAR(1)  NO 
 
Status    CHAR(1)  NO 
 
CalculationPeriod    CHAR(1)  NO 
 
TermId(FK)    INTEGER  YES 
 
AcademicYearSequence    TINYINT  YES 
 
Note    VARCHAR(2000)  YES 
 
RefundsPayableDueDate    DATETIME  YES 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
LastModifiedUserId    INTEGER  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentRt4CalculationId(FK)    INTEGER  YES 
 
LastDateOfAttendance    DATETIME  YES 
 
IsRt4CalculationNotRequired    BIT  NO 
 
EligibilityStatus    CHAR(1)  NO 
 
IsCalculationAutoApproved    BIT  NO 
 
RefundCalculationStatusId(FK)    INTEGER  YES 
 
RefundCalculationActionId(FK)    INTEGER  YES 
 
ApprovedDate    DATETIME  YES 
 
NSLDSWithdrawalDate    DATETIME  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 
Rt4CalculationPeriod    CHAR(1)  YES 
 
CeasedAttendingDate    DATETIME  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 

StudentRefundCalculation Keys 
Key Name  Key Type  Keys 
SaRefundCalc_SaRefundCalcID_U_C_IDX  PrimaryKey  StudentRefundCalculationId 
SaRefundCalc_FaStudentAyPaymentPeriodId_N_N_IDX  Inversion Entry  StudentAcademicYearPaymentPeriodId 
Nk_SaRefundCalcSaRefundCalculationStatusId_SaRefundCalculationStatusSaRefundCalculationStatusId  Inversion Entry  RefundCalculationStatusId 

StudentRefundCalculation Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
RefundCalculationAction  Non-Identifying  Zero or One to Zero or More        RefundCalculationActionId  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        RefundCalculationStatusId  NO 
RefundCalculationAction  Non-Identifying  Zero or One to Zero or More        RefundCalculationActionId  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        RefundCalculationStatusId  NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentRt4Calculation  Non-Identifying  Zero or One to Zero or More        StudentRt4CalculationId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
SaRefundCalcStudentGroup_FAA  Non-Identifying  One To Zero or More          NO 
SaRefundCalcStudentGroup  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationAssignment  Non-Identifying  One To Zero or More          NO 
SaRefundCalculationWorkflowAudit  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
StipendSchedule  Non-Identifying  One To Zero or More          NO 
StudentRefundCalculationPolicySummary  Non-Identifying  One To Zero or More          NO 

StudentRefundCalculation Check Constraints 
Check Constraint Name  CheckConstraint